Tabela GPPatientIdentification

Definicja tabeli GPPatientIdentification

Name

GPPatientIdentification

Code

GPPatientIdentification

Comment

 


Lista kolumn tabeli GPPatientIdentification

Name

Code

PatientID

PatientID

PatientIdentificationNo

PatientIdentificationNo

IdentificationTypeID

IdentificationTypeID

GuardianID

GuardianID


Kolumna PatientID tabeli GPPatientIdentification

Definicja kolumny PatientID tabeli GPPatientIdentification

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientIdentificationNo tabeli GPPatientIdentification

Definicja kolumny PatientIdentificationNo tabeli GPPatientIdentification

Name

PatientIdentificationNo

Code

PatientIdentificationNo

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna IdentificationTypeID tabeli GPPatientIdentification

Definicja kolumny IdentificationTypeID tabeli GPPatientIdentification

Name

IdentificationTypeID

Code

IdentificationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna GuardianID tabeli GPPatientIdentification

Definicja kolumny GuardianID tabeli GPPatientIdentification

Name

GuardianID

Code

GuardianID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli GPPatientIdentification

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli GPPatientIdentification

Definicja klucza Identifier_1 tabeli GPPatientIdentification

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment